ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
USE INSTRUCTIONS
2
3
This workbook calculates temperature data values necessary for completing your DMR forms.
4
5
BE CAREFUL! CUTTING & PASTING NUMBERS FROM OTHER SPREADSHEETS MAY
6
GENERATE CALCULATION ERRORS
7
8
The sheets in this workbook are password protected to help prevent inadvertent modification. If
9
you really feel that you must modify a sheet the password is "bill".
10
11
Where columns or numbers are shown in blue the areas are unprotected and you can insert your
12
data. Use these columns to enter your temperature data from your data logger downloads. Reporting for
13
each month requires some data from the last days of the prior month and first days of the next month.
14
Some of the last days data have been carried forward to the next month by equations to assist you.
15
If you are starting in a month other than January, overwrite the equations in Column B so data is complete.
16
17
Be sure to enter temperature values aligned with the correct day and time in the first column of each month.
18
Charts are provided in cell G5 to X35 to visualize any outlier values in the data entered.
19
20
DMR REPORTING VALUES are shown on the DMR_ReportingSheet.
21
A reporting values of #DIV/0! indicates data is missing for one of the date/time intervals on the monthly sheet.
22
23
We have made every effort to be sure the calculations are correct in each sheet. There are, however,
24
no guarantees. Use this workbook at your own risk and check the numbers from time to time.
25
If you encounter problems with this workbook please contact me at casey.kay@state.co.us
26
or 970-248-7154. Enjoy!
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100